package cn.alibab.cangku.dao;

import cn.alibab.cangku.vo.ProductVo;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface AreaDao {
    @Select("SELECT pName FROM(SELECT * FROM `biz_product_stock_category` WHERE a_num IN" +
            "(SELECT a_num FROM `biz_stock_category` WHERE areas=#{area}) ) \n" +
            "AS newtable INNER JOIN `biz_product` ON newtable.p_num=biz_product.`p_num`")
    List<ProductVo> findByArea(@Param("area")String area);
}
